{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "b567ee9b-44a2-4dc1-ae3a-ee299b95d7bd",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "plt.rcParams['font.sans-serif'] = ['SimHei'] # 用来正常显示中文标签\n",
    "plt.rcParams['axes.unicode_minus'] = False # 用来正常显示负号"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "0641ffc4-13e3-4be1-8ec8-741009c2ebf5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>客户下单条目ID</th>\n",
       "      <th>客户信息ID</th>\n",
       "      <th>站点信息ID</th>\n",
       "      <th>需求吨位</th>\n",
       "      <th>货运方式字典值</th>\n",
       "      <th>业务类型描述</th>\n",
       "      <th>发货地址ID</th>\n",
       "      <th>到站时间</th>\n",
       "      <th>创建该订单的我司销售人员</th>\n",
       "      <th>名称</th>\n",
       "      <th>客户名称</th>\n",
       "      <th>发货地名称</th>\n",
       "      <th>货品类型</th>\n",
       "      <th>产品规格</th>\n",
       "      <th>产品品牌</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>79</td>\n",
       "      <td>37</td>\n",
       "      <td>46</td>\n",
       "      <td>100.00</td>\n",
       "      <td>1</td>\n",
       "      <td>配送 (贸易+起驳+运输)</td>\n",
       "      <td>121</td>\n",
       "      <td>2022-06-13 15:59:10</td>\n",
       "      <td>xssb</td>\n",
       "      <td>三部测试</td>\n",
       "      <td>NaN</td>\n",
       "      <td>江南码头</td>\n",
       "      <td>水泥</td>\n",
       "      <td>P.O42.5</td>\n",
       "      <td>海螺水泥</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>745</td>\n",
       "      <td>141</td>\n",
       "      <td>276</td>\n",
       "      <td>100.00</td>\n",
       "      <td>1</td>\n",
       "      <td>配送 (贸易+起驳+运输)</td>\n",
       "      <td>121</td>\n",
       "      <td>2022-06-29 05:46:42</td>\n",
       "      <td>DS0403001</td>\n",
       "      <td>何义奎</td>\n",
       "      <td>盛华鑫</td>\n",
       "      <td>江南码头</td>\n",
       "      <td>水泥</td>\n",
       "      <td>P.O42.5</td>\n",
       "      <td>海螺水泥</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>865</td>\n",
       "      <td>141</td>\n",
       "      <td>276</td>\n",
       "      <td>200.00</td>\n",
       "      <td>1</td>\n",
       "      <td>配送 (贸易+起驳+运输)</td>\n",
       "      <td>121</td>\n",
       "      <td>2022-07-01 04:30:19</td>\n",
       "      <td>DS0403001</td>\n",
       "      <td>何义奎</td>\n",
       "      <td>盛华鑫</td>\n",
       "      <td>江南码头</td>\n",
       "      <td>水泥</td>\n",
       "      <td>P.O42.5</td>\n",
       "      <td>海螺水泥</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>928</td>\n",
       "      <td>141</td>\n",
       "      <td>276</td>\n",
       "      <td>200.00</td>\n",
       "      <td>1</td>\n",
       "      <td>配送 (贸易+起驳+运输)</td>\n",
       "      <td>121</td>\n",
       "      <td>2022-07-02 10:46:07</td>\n",
       "      <td>DS0403001</td>\n",
       "      <td>何义奎</td>\n",
       "      <td>盛华鑫</td>\n",
       "      <td>江南码头</td>\n",
       "      <td>水泥</td>\n",
       "      <td>P.O42.5</td>\n",
       "      <td>海螺水泥</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>958</td>\n",
       "      <td>141</td>\n",
       "      <td>276</td>\n",
       "      <td>150.00</td>\n",
       "      <td>1</td>\n",
       "      <td>配送 (贸易+起驳+运输)</td>\n",
       "      <td>121</td>\n",
       "      <td>2022-07-03 04:27:59</td>\n",
       "      <td>DS0403001</td>\n",
       "      <td>何义奎</td>\n",
       "      <td>盛华鑫</td>\n",
       "      <td>江南码头</td>\n",
       "      <td>水泥</td>\n",
       "      <td>P.O42.5</td>\n",
       "      <td>海螺水泥</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27948</th>\n",
       "      <td>27948</td>\n",
       "      <td>32911</td>\n",
       "      <td>388</td>\n",
       "      <td>1278</td>\n",
       "      <td>35.00</td>\n",
       "      <td>0</td>\n",
       "      <td>自提 (贸易)</td>\n",
       "      <td>104</td>\n",
       "      <td>2024-06-24 08:05:00</td>\n",
       "      <td>DS0403003</td>\n",
       "      <td>史丹</td>\n",
       "      <td>泽麟建材</td>\n",
       "      <td>武新一期</td>\n",
       "      <td>矿粉</td>\n",
       "      <td>S95</td>\n",
       "      <td>武新矿粉</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27949</th>\n",
       "      <td>27949</td>\n",
       "      <td>32912</td>\n",
       "      <td>636</td>\n",
       "      <td>1211</td>\n",
       "      <td>35.00</td>\n",
       "      <td>0</td>\n",
       "      <td>自提 (贸易)</td>\n",
       "      <td>104</td>\n",
       "      <td>2024-06-24 08:05:00</td>\n",
       "      <td>DS0403003</td>\n",
       "      <td>史丹</td>\n",
       "      <td>枣阳翔吉顺</td>\n",
       "      <td>武新一期</td>\n",
       "      <td>矿粉</td>\n",
       "      <td>S95</td>\n",
       "      <td>武新矿粉</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27950</th>\n",
       "      <td>27950</td>\n",
       "      <td>32913</td>\n",
       "      <td>497</td>\n",
       "      <td>1274</td>\n",
       "      <td>42.36</td>\n",
       "      <td>0</td>\n",
       "      <td>自提 (贸易)</td>\n",
       "      <td>104</td>\n",
       "      <td>2024-06-05 08:05:00</td>\n",
       "      <td>chediao</td>\n",
       "      <td>调度室</td>\n",
       "      <td>志扬云睿</td>\n",
       "      <td>武新一期</td>\n",
       "      <td>矿粉</td>\n",
       "      <td>S95</td>\n",
       "      <td>武新矿粉</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27951</th>\n",
       "      <td>27951</td>\n",
       "      <td>32914</td>\n",
       "      <td>479</td>\n",
       "      <td>793</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0</td>\n",
       "      <td>自提 (贸易)</td>\n",
       "      <td>104</td>\n",
       "      <td>2024-06-24 08:05:00</td>\n",
       "      <td>DS0402003</td>\n",
       "      <td>甄常</td>\n",
       "      <td>荟聚源</td>\n",
       "      <td>武新一期</td>\n",
       "      <td>矿粉</td>\n",
       "      <td>S95</td>\n",
       "      <td>武新矿粉</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27952</th>\n",
       "      <td>27952</td>\n",
       "      <td>32915</td>\n",
       "      <td>546</td>\n",
       "      <td>979</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0</td>\n",
       "      <td>配送 (贸易+运输)</td>\n",
       "      <td>105</td>\n",
       "      <td>2024-06-25 08:05:00</td>\n",
       "      <td>DS0403000</td>\n",
       "      <td>李庭辉</td>\n",
       "      <td>湖北玖伍建材</td>\n",
       "      <td>武新二期</td>\n",
       "      <td>矿粉</td>\n",
       "      <td>S95</td>\n",
       "      <td>武新矿粉</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>27953 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0  客户下单条目ID  客户信息ID  站点信息ID    需求吨位  货运方式字典值         业务类型描述  \\\n",
       "0               0        79      37      46  100.00        1  配送 (贸易+起驳+运输)   \n",
       "1               1       745     141     276  100.00        1  配送 (贸易+起驳+运输)   \n",
       "2               2       865     141     276  200.00        1  配送 (贸易+起驳+运输)   \n",
       "3               3       928     141     276  200.00        1  配送 (贸易+起驳+运输)   \n",
       "4               4       958     141     276  150.00        1  配送 (贸易+起驳+运输)   \n",
       "...           ...       ...     ...     ...     ...      ...            ...   \n",
       "27948       27948     32911     388    1278   35.00        0        自提 (贸易)   \n",
       "27949       27949     32912     636    1211   35.00        0        自提 (贸易)   \n",
       "27950       27950     32913     497    1274   42.36        0        自提 (贸易)   \n",
       "27951       27951     32914     479     793   30.00        0        自提 (贸易)   \n",
       "27952       27952     32915     546     979   30.00        0     配送 (贸易+运输)   \n",
       "\n",
       "       发货地址ID                 到站时间 创建该订单的我司销售人员    名称    客户名称 发货地名称 货品类型  \\\n",
       "0         121  2022-06-13 15:59:10         xssb  三部测试     NaN  江南码头   水泥   \n",
       "1         121  2022-06-29 05:46:42    DS0403001   何义奎     盛华鑫  江南码头   水泥   \n",
       "2         121  2022-07-01 04:30:19    DS0403001   何义奎     盛华鑫  江南码头   水泥   \n",
       "3         121  2022-07-02 10:46:07    DS0403001   何义奎     盛华鑫  江南码头   水泥   \n",
       "4         121  2022-07-03 04:27:59    DS0403001   何义奎     盛华鑫  江南码头   水泥   \n",
       "...       ...                  ...          ...   ...     ...   ...  ...   \n",
       "27948     104  2024-06-24 08:05:00    DS0403003    史丹    泽麟建材  武新一期   矿粉   \n",
       "27949     104  2024-06-24 08:05:00    DS0403003    史丹   枣阳翔吉顺  武新一期   矿粉   \n",
       "27950     104  2024-06-05 08:05:00      chediao   调度室    志扬云睿  武新一期   矿粉   \n",
       "27951     104  2024-06-24 08:05:00    DS0402003    甄常     荟聚源  武新一期   矿粉   \n",
       "27952     105  2024-06-25 08:05:00    DS0403000   李庭辉  湖北玖伍建材  武新二期   矿粉   \n",
       "\n",
       "          产品规格  产品品牌  \n",
       "0      P.O42.5  海螺水泥  \n",
       "1      P.O42.5  海螺水泥  \n",
       "2      P.O42.5  海螺水泥  \n",
       "3      P.O42.5  海螺水泥  \n",
       "4      P.O42.5  海螺水泥  \n",
       "...        ...   ...  \n",
       "27948      S95  武新矿粉  \n",
       "27949      S95  武新矿粉  \n",
       "27950      S95  武新矿粉  \n",
       "27951      S95  武新矿粉  \n",
       "27952      S95  武新矿粉  \n",
       "\n",
       "[27953 rows x 16 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2=pd.read_excel(\"cppp.xlsx\")\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "07ddcb78-affd-4174-97e5-e1074ac35dd1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>调度安排ID</th>\n",
       "      <th>客户信息ID</th>\n",
       "      <th>站点信息ID</th>\n",
       "      <th>客户下单ID</th>\n",
       "      <th>发货地信息ID</th>\n",
       "      <th>货品类型</th>\n",
       "      <th>产品规格</th>\n",
       "      <th>产品品牌</th>\n",
       "      <th>发货吨位</th>\n",
       "      <th>到站吨位</th>\n",
       "      <th>单价</th>\n",
       "      <th>货款</th>\n",
       "      <th>车辆信息</th>\n",
       "      <th>收货时间</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2509</td>\n",
       "      <td>3624</td>\n",
       "      <td>218</td>\n",
       "      <td>319</td>\n",
       "      <td>1978</td>\n",
       "      <td>103</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>38.38</td>\n",
       "      <td>0.0</td>\n",
       "      <td>207.0</td>\n",
       "      <td>7944.66</td>\n",
       "      <td>314</td>\n",
       "      <td>2022-07-21 07:10:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2510</td>\n",
       "      <td>3637</td>\n",
       "      <td>107</td>\n",
       "      <td>93</td>\n",
       "      <td>1981</td>\n",
       "      <td>124</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>45.56</td>\n",
       "      <td>0.0</td>\n",
       "      <td>340.0</td>\n",
       "      <td>15490.40</td>\n",
       "      <td>241</td>\n",
       "      <td>2022-07-21 07:19:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2514</td>\n",
       "      <td>3638</td>\n",
       "      <td>152</td>\n",
       "      <td>191</td>\n",
       "      <td>1986</td>\n",
       "      <td>121</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>43.84</td>\n",
       "      <td>0.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>14028.80</td>\n",
       "      <td>276</td>\n",
       "      <td>2022-07-21 10:49:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2515</td>\n",
       "      <td>3639</td>\n",
       "      <td>152</td>\n",
       "      <td>191</td>\n",
       "      <td>1986</td>\n",
       "      <td>121</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52.20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>16704.00</td>\n",
       "      <td>257</td>\n",
       "      <td>2022-07-21 10:49:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2516</td>\n",
       "      <td>3666</td>\n",
       "      <td>139</td>\n",
       "      <td>141</td>\n",
       "      <td>1998</td>\n",
       "      <td>104</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>32.32</td>\n",
       "      <td>0.0</td>\n",
       "      <td>292.0</td>\n",
       "      <td>9437.44</td>\n",
       "      <td>163</td>\n",
       "      <td>2022-07-21 11:23:31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49870</th>\n",
       "      <td>60712</td>\n",
       "      <td>62734</td>\n",
       "      <td>461</td>\n",
       "      <td>744</td>\n",
       "      <td>32869</td>\n",
       "      <td>104</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>36.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1800.00</td>\n",
       "      <td>1345</td>\n",
       "      <td>2024-06-24 13:28:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49871</th>\n",
       "      <td>60713</td>\n",
       "      <td>62747</td>\n",
       "      <td>609</td>\n",
       "      <td>1145</td>\n",
       "      <td>32886</td>\n",
       "      <td>105</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>41.16</td>\n",
       "      <td>0.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>6379.80</td>\n",
       "      <td>106</td>\n",
       "      <td>2024-06-24 14:08:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49872</th>\n",
       "      <td>60714</td>\n",
       "      <td>62748</td>\n",
       "      <td>103</td>\n",
       "      <td>87</td>\n",
       "      <td>32893</td>\n",
       "      <td>104</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>34.60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>5363.00</td>\n",
       "      <td>226</td>\n",
       "      <td>2024-06-24 14:09:20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49873</th>\n",
       "      <td>60715</td>\n",
       "      <td>62745</td>\n",
       "      <td>201</td>\n",
       "      <td>892</td>\n",
       "      <td>32890</td>\n",
       "      <td>104</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>40.64</td>\n",
       "      <td>0.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>6908.80</td>\n",
       "      <td>125</td>\n",
       "      <td>2024-06-24 14:40:16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49874</th>\n",
       "      <td>60716</td>\n",
       "      <td>62744</td>\n",
       "      <td>388</td>\n",
       "      <td>1278</td>\n",
       "      <td>32911</td>\n",
       "      <td>105</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>35.68</td>\n",
       "      <td>0.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>5352.00</td>\n",
       "      <td>766</td>\n",
       "      <td>2024-06-24 15:07:41</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>49875 rows × 15 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          ID  调度安排ID  客户信息ID  站点信息ID  客户下单ID  发货地信息ID  货品类型  产品规格  产品品牌  \\\n",
       "0       2509    3624     218     319    1978      103     1     1     8   \n",
       "1       2510    3637     107      93    1981      124     0     0     0   \n",
       "2       2514    3638     152     191    1986      121     0     0     0   \n",
       "3       2515    3639     152     191    1986      121     0     0     0   \n",
       "4       2516    3666     139     141    1998      104     1     1     9   \n",
       "...      ...     ...     ...     ...     ...      ...   ...   ...   ...   \n",
       "49870  60712   62734     461     744   32869      104     1     1     9   \n",
       "49871  60713   62747     609    1145   32886      105     1     1     9   \n",
       "49872  60714   62748     103      87   32893      104     1     1     9   \n",
       "49873  60715   62745     201     892   32890      104     1     1     9   \n",
       "49874  60716   62744     388    1278   32911      105     1     1     9   \n",
       "\n",
       "        发货吨位  到站吨位     单价        货款  车辆信息                 收货时间  \n",
       "0      38.38   0.0  207.0   7944.66   314  2022-07-21 07:10:48  \n",
       "1      45.56   0.0  340.0  15490.40   241  2022-07-21 07:19:48  \n",
       "2      43.84   0.0  320.0  14028.80   276  2022-07-21 10:49:34  \n",
       "3      52.20   0.0  320.0  16704.00   257  2022-07-21 10:49:35  \n",
       "4      32.32   0.0  292.0   9437.44   163  2022-07-21 11:23:31  \n",
       "...      ...   ...    ...       ...   ...                  ...  \n",
       "49870  36.00   0.0   50.0   1800.00  1345  2024-06-24 13:28:49  \n",
       "49871  41.16   0.0  155.0   6379.80   106  2024-06-24 14:08:54  \n",
       "49872  34.60   0.0  155.0   5363.00   226  2024-06-24 14:09:20  \n",
       "49873  40.64   0.0  170.0   6908.80   125  2024-06-24 14:40:16  \n",
       "49874  35.68   0.0  150.0   5352.00   766  2024-06-24 15:07:41  \n",
       "\n",
       "[49875 rows x 15 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1=pd.read_csv(\"data/ERP_FHJL.csv\")\n",
    "df1.columns=[\"ID\",\"调度安排ID\",\"客户信息ID\",\"站点信息ID\",\"客户下单ID\",\"发货地信息ID\",\"货品类型\",\"产品规格\",\"产品品牌\",\"发货吨位\",\"到站吨位\",\"单价\",\"货款\",\"车辆信息\",\"收货时间\"]\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "4e2d7d31-2f02-439b-b4c6-86ed2501c034",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>发货记录ID</th>\n",
       "      <th>发货记录完成时间</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>2509</td>\n",
       "      <td>2022-07-21 07:10:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2510</td>\n",
       "      <td>2022-07-21 07:19:48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2514</td>\n",
       "      <td>2022-07-21 10:49:34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2515</td>\n",
       "      <td>2022-07-21 10:49:35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2516</td>\n",
       "      <td>2022-07-21 11:23:31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49870</th>\n",
       "      <td>49870</td>\n",
       "      <td>60712</td>\n",
       "      <td>2024-06-24 13:28:49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49871</th>\n",
       "      <td>49871</td>\n",
       "      <td>60713</td>\n",
       "      <td>2024-06-24 14:08:54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49872</th>\n",
       "      <td>49872</td>\n",
       "      <td>60714</td>\n",
       "      <td>2024-06-24 14:09:20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49873</th>\n",
       "      <td>49873</td>\n",
       "      <td>60715</td>\n",
       "      <td>2024-06-24 14:40:16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49874</th>\n",
       "      <td>49874</td>\n",
       "      <td>60716</td>\n",
       "      <td>2024-06-24 15:07:41</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>49875 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0  发货记录ID             发货记录完成时间\n",
       "0               0    2509  2022-07-21 07:10:48\n",
       "1               1    2510  2022-07-21 07:19:48\n",
       "2               2    2514  2022-07-21 10:49:34\n",
       "3               3    2515  2022-07-21 10:49:35\n",
       "4               4    2516  2022-07-21 11:23:31\n",
       "...           ...     ...                  ...\n",
       "49870       49870   60712  2024-06-24 13:28:49\n",
       "49871       49871   60713  2024-06-24 14:08:54\n",
       "49872       49872   60714  2024-06-24 14:09:20\n",
       "49873       49873   60715  2024-06-24 14:40:16\n",
       "49874       49874   60716  2024-06-24 15:07:41\n",
       "\n",
       "[49875 rows x 3 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3=pd.read_excel(\"新.xlsx\")\n",
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "ed10dc7c-e0f8-40a2-85ef-b1e9e78d21d5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>发货记录ID</th>\n",
       "      <th>发货记录完成时间</th>\n",
       "      <th>发货吨位</th>\n",
       "      <th>到站吨位</th>\n",
       "      <th>单价</th>\n",
       "      <th>货款</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>2509</td>\n",
       "      <td>2022-07-21 07:10:48</td>\n",
       "      <td>38.38</td>\n",
       "      <td>0.0</td>\n",
       "      <td>207.0</td>\n",
       "      <td>7944.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2510</td>\n",
       "      <td>2022-07-21 07:19:48</td>\n",
       "      <td>45.56</td>\n",
       "      <td>0.0</td>\n",
       "      <td>340.0</td>\n",
       "      <td>15490.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2514</td>\n",
       "      <td>2022-07-21 10:49:34</td>\n",
       "      <td>43.84</td>\n",
       "      <td>0.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>14028.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2515</td>\n",
       "      <td>2022-07-21 10:49:35</td>\n",
       "      <td>52.20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>16704.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2516</td>\n",
       "      <td>2022-07-21 11:23:31</td>\n",
       "      <td>32.32</td>\n",
       "      <td>0.0</td>\n",
       "      <td>292.0</td>\n",
       "      <td>9437.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49870</th>\n",
       "      <td>49870</td>\n",
       "      <td>60712</td>\n",
       "      <td>2024-06-24 13:28:49</td>\n",
       "      <td>36.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1800.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49871</th>\n",
       "      <td>49871</td>\n",
       "      <td>60713</td>\n",
       "      <td>2024-06-24 14:08:54</td>\n",
       "      <td>41.16</td>\n",
       "      <td>0.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>6379.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49872</th>\n",
       "      <td>49872</td>\n",
       "      <td>60714</td>\n",
       "      <td>2024-06-24 14:09:20</td>\n",
       "      <td>34.60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>5363.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49873</th>\n",
       "      <td>49873</td>\n",
       "      <td>60715</td>\n",
       "      <td>2024-06-24 14:40:16</td>\n",
       "      <td>40.64</td>\n",
       "      <td>0.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>6908.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49874</th>\n",
       "      <td>49874</td>\n",
       "      <td>60716</td>\n",
       "      <td>2024-06-24 15:07:41</td>\n",
       "      <td>35.68</td>\n",
       "      <td>0.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>5352.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>49875 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0  发货记录ID             发货记录完成时间   发货吨位  到站吨位     单价        货款\n",
       "0               0    2509  2022-07-21 07:10:48  38.38   0.0  207.0   7944.66\n",
       "1               1    2510  2022-07-21 07:19:48  45.56   0.0  340.0  15490.40\n",
       "2               2    2514  2022-07-21 10:49:34  43.84   0.0  320.0  14028.80\n",
       "3               3    2515  2022-07-21 10:49:35  52.20   0.0  320.0  16704.00\n",
       "4               4    2516  2022-07-21 11:23:31  32.32   0.0  292.0   9437.44\n",
       "...           ...     ...                  ...    ...   ...    ...       ...\n",
       "49870       49870   60712  2024-06-24 13:28:49  36.00   0.0   50.0   1800.00\n",
       "49871       49871   60713  2024-06-24 14:08:54  41.16   0.0  155.0   6379.80\n",
       "49872       49872   60714  2024-06-24 14:09:20  34.60   0.0  155.0   5363.00\n",
       "49873       49873   60715  2024-06-24 14:40:16  40.64   0.0  170.0   6908.80\n",
       "49874       49874   60716  2024-06-24 15:07:41  35.68   0.0  150.0   5352.00\n",
       "\n",
       "[49875 rows x 7 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3[\"发货吨位\"]=df1[\"发货吨位\"]\n",
    "df3[\"到站吨位\"]=df1[\"到站吨位\"]\n",
    "df3[\"单价\"]=df1[\"货物单价\"]\n",
    "df3[\"货款\"]=df1[\"货款\"]\n",
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "229036a8-8e49-4735-95fe-78fa1fe5bcfa",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>车辆信息</th>\n",
       "      <th>具体车牌号</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1827</td>\n",
       "      <td>\\t 鄂AJC558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1802</td>\n",
       "      <td>鄂AKX820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1803</td>\n",
       "      <td>鄂AKX820</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1755</td>\n",
       "      <td>鄂AUL326</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1352</td>\n",
       "      <td>.鄂AAL515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2006</th>\n",
       "      <td>1093</td>\n",
       "      <td>鄂S765A2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2007</th>\n",
       "      <td>492</td>\n",
       "      <td>鄂S769A6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2008</th>\n",
       "      <td>1091</td>\n",
       "      <td>鄂S827A0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2009</th>\n",
       "      <td>1442</td>\n",
       "      <td>鄂SE3272</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2010</th>\n",
       "      <td>1740</td>\n",
       "      <td>，鄂ANJ829</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2011 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      车辆信息       具体车牌号\n",
       "0     1827  \\t 鄂AJC558\n",
       "1     1802     鄂AKX820\n",
       "2     1803     鄂AKX820\n",
       "3     1755     鄂AUL326\n",
       "4     1352    .鄂AAL515\n",
       "...    ...         ...\n",
       "2006  1093     鄂S765A2\n",
       "2007   492     鄂S769A6\n",
       "2008  1091     鄂S827A0\n",
       "2009  1442     鄂SE3272\n",
       "2010  1740    ，鄂ANJ829\n",
       "\n",
       "[2011 rows x 2 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4=pd.read_csv(\"数据/车辆信息表.csv\")\n",
    "df4.columns=[\"车辆信息\",\"具体车牌号\"]\n",
    "df4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "7636b100-3455-440e-97f1-ef1f5772fb29",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>发货记录ID</th>\n",
       "      <th>发货记录完成时间</th>\n",
       "      <th>发货吨位</th>\n",
       "      <th>到站吨位</th>\n",
       "      <th>单价</th>\n",
       "      <th>货款</th>\n",
       "      <th>车辆信息</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>2509</td>\n",
       "      <td>2022-07-21 07:10:48</td>\n",
       "      <td>38.38</td>\n",
       "      <td>0.0</td>\n",
       "      <td>207.0</td>\n",
       "      <td>7944.66</td>\n",
       "      <td>314</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2510</td>\n",
       "      <td>2022-07-21 07:19:48</td>\n",
       "      <td>45.56</td>\n",
       "      <td>0.0</td>\n",
       "      <td>340.0</td>\n",
       "      <td>15490.40</td>\n",
       "      <td>241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2514</td>\n",
       "      <td>2022-07-21 10:49:34</td>\n",
       "      <td>43.84</td>\n",
       "      <td>0.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>14028.80</td>\n",
       "      <td>276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2515</td>\n",
       "      <td>2022-07-21 10:49:35</td>\n",
       "      <td>52.20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>16704.00</td>\n",
       "      <td>257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2516</td>\n",
       "      <td>2022-07-21 11:23:31</td>\n",
       "      <td>32.32</td>\n",
       "      <td>0.0</td>\n",
       "      <td>292.0</td>\n",
       "      <td>9437.44</td>\n",
       "      <td>163</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49870</th>\n",
       "      <td>49870</td>\n",
       "      <td>60712</td>\n",
       "      <td>2024-06-24 13:28:49</td>\n",
       "      <td>36.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1800.00</td>\n",
       "      <td>1345</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49871</th>\n",
       "      <td>49871</td>\n",
       "      <td>60713</td>\n",
       "      <td>2024-06-24 14:08:54</td>\n",
       "      <td>41.16</td>\n",
       "      <td>0.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>6379.80</td>\n",
       "      <td>106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49872</th>\n",
       "      <td>49872</td>\n",
       "      <td>60714</td>\n",
       "      <td>2024-06-24 14:09:20</td>\n",
       "      <td>34.60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>5363.00</td>\n",
       "      <td>226</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49873</th>\n",
       "      <td>49873</td>\n",
       "      <td>60715</td>\n",
       "      <td>2024-06-24 14:40:16</td>\n",
       "      <td>40.64</td>\n",
       "      <td>0.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>6908.80</td>\n",
       "      <td>125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49874</th>\n",
       "      <td>49874</td>\n",
       "      <td>60716</td>\n",
       "      <td>2024-06-24 15:07:41</td>\n",
       "      <td>35.68</td>\n",
       "      <td>0.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>5352.00</td>\n",
       "      <td>766</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>49875 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0  发货记录ID             发货记录完成时间   发货吨位  到站吨位     单价        货款  \\\n",
       "0               0    2509  2022-07-21 07:10:48  38.38   0.0  207.0   7944.66   \n",
       "1               1    2510  2022-07-21 07:19:48  45.56   0.0  340.0  15490.40   \n",
       "2               2    2514  2022-07-21 10:49:34  43.84   0.0  320.0  14028.80   \n",
       "3               3    2515  2022-07-21 10:49:35  52.20   0.0  320.0  16704.00   \n",
       "4               4    2516  2022-07-21 11:23:31  32.32   0.0  292.0   9437.44   \n",
       "...           ...     ...                  ...    ...   ...    ...       ...   \n",
       "49870       49870   60712  2024-06-24 13:28:49  36.00   0.0   50.0   1800.00   \n",
       "49871       49871   60713  2024-06-24 14:08:54  41.16   0.0  155.0   6379.80   \n",
       "49872       49872   60714  2024-06-24 14:09:20  34.60   0.0  155.0   5363.00   \n",
       "49873       49873   60715  2024-06-24 14:40:16  40.64   0.0  170.0   6908.80   \n",
       "49874       49874   60716  2024-06-24 15:07:41  35.68   0.0  150.0   5352.00   \n",
       "\n",
       "       车辆信息  \n",
       "0       314  \n",
       "1       241  \n",
       "2       276  \n",
       "3       257  \n",
       "4       163  \n",
       "...     ...  \n",
       "49870  1345  \n",
       "49871   106  \n",
       "49872   226  \n",
       "49873   125  \n",
       "49874   766  \n",
       "\n",
       "[49875 rows x 8 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3[\"车辆信息\"]=df1[\"车辆信息\"]\n",
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "9ec6862d-a115-40b1-a763-0a04a22cd396",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>发货记录ID</th>\n",
       "      <th>发货记录完成时间</th>\n",
       "      <th>发货吨位</th>\n",
       "      <th>到站吨位</th>\n",
       "      <th>单价</th>\n",
       "      <th>货款</th>\n",
       "      <th>车辆信息</th>\n",
       "      <th>具体车牌号</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>2509</td>\n",
       "      <td>2022-07-21 07:10:48</td>\n",
       "      <td>38.38</td>\n",
       "      <td>0.0</td>\n",
       "      <td>207.0</td>\n",
       "      <td>7944.66</td>\n",
       "      <td>314</td>\n",
       "      <td>鄂L1D516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2510</td>\n",
       "      <td>2022-07-21 07:19:48</td>\n",
       "      <td>45.56</td>\n",
       "      <td>0.0</td>\n",
       "      <td>340.0</td>\n",
       "      <td>15490.40</td>\n",
       "      <td>241</td>\n",
       "      <td>鄂AEJ919</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2514</td>\n",
       "      <td>2022-07-21 10:49:34</td>\n",
       "      <td>43.84</td>\n",
       "      <td>0.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>14028.80</td>\n",
       "      <td>276</td>\n",
       "      <td>鄂ASE558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2515</td>\n",
       "      <td>2022-07-21 10:49:35</td>\n",
       "      <td>52.20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>16704.00</td>\n",
       "      <td>257</td>\n",
       "      <td>鄂APP387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2516</td>\n",
       "      <td>2022-07-21 11:23:31</td>\n",
       "      <td>32.32</td>\n",
       "      <td>0.0</td>\n",
       "      <td>292.0</td>\n",
       "      <td>9437.44</td>\n",
       "      <td>163</td>\n",
       "      <td>鄂APS131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49870</th>\n",
       "      <td>49870</td>\n",
       "      <td>60712</td>\n",
       "      <td>2024-06-24 13:28:49</td>\n",
       "      <td>36.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1800.00</td>\n",
       "      <td>1345</td>\n",
       "      <td>鄂AET276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49871</th>\n",
       "      <td>49871</td>\n",
       "      <td>60713</td>\n",
       "      <td>2024-06-24 14:08:54</td>\n",
       "      <td>41.16</td>\n",
       "      <td>0.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>6379.80</td>\n",
       "      <td>106</td>\n",
       "      <td>鄂ABQ252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49872</th>\n",
       "      <td>49872</td>\n",
       "      <td>60714</td>\n",
       "      <td>2024-06-24 14:09:20</td>\n",
       "      <td>34.60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>5363.00</td>\n",
       "      <td>226</td>\n",
       "      <td>鄂ADM620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49873</th>\n",
       "      <td>49873</td>\n",
       "      <td>60715</td>\n",
       "      <td>2024-06-24 14:40:16</td>\n",
       "      <td>40.64</td>\n",
       "      <td>0.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>6908.80</td>\n",
       "      <td>125</td>\n",
       "      <td>鄂ABB206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49874</th>\n",
       "      <td>49874</td>\n",
       "      <td>60716</td>\n",
       "      <td>2024-06-24 15:07:41</td>\n",
       "      <td>35.68</td>\n",
       "      <td>0.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>5352.00</td>\n",
       "      <td>766</td>\n",
       "      <td>鄂ACK879</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>49875 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0  发货记录ID             发货记录完成时间   发货吨位  到站吨位     单价        货款  \\\n",
       "0               0    2509  2022-07-21 07:10:48  38.38   0.0  207.0   7944.66   \n",
       "1               1    2510  2022-07-21 07:19:48  45.56   0.0  340.0  15490.40   \n",
       "2               2    2514  2022-07-21 10:49:34  43.84   0.0  320.0  14028.80   \n",
       "3               3    2515  2022-07-21 10:49:35  52.20   0.0  320.0  16704.00   \n",
       "4               4    2516  2022-07-21 11:23:31  32.32   0.0  292.0   9437.44   \n",
       "...           ...     ...                  ...    ...   ...    ...       ...   \n",
       "49870       49870   60712  2024-06-24 13:28:49  36.00   0.0   50.0   1800.00   \n",
       "49871       49871   60713  2024-06-24 14:08:54  41.16   0.0  155.0   6379.80   \n",
       "49872       49872   60714  2024-06-24 14:09:20  34.60   0.0  155.0   5363.00   \n",
       "49873       49873   60715  2024-06-24 14:40:16  40.64   0.0  170.0   6908.80   \n",
       "49874       49874   60716  2024-06-24 15:07:41  35.68   0.0  150.0   5352.00   \n",
       "\n",
       "       车辆信息    具体车牌号  \n",
       "0       314  鄂L1D516  \n",
       "1       241  鄂AEJ919  \n",
       "2       276  鄂ASE558  \n",
       "3       257  鄂APP387  \n",
       "4       163  鄂APS131  \n",
       "...     ...      ...  \n",
       "49870  1345  鄂AET276  \n",
       "49871   106  鄂ABQ252  \n",
       "49872   226  鄂ADM620  \n",
       "49873   125  鄂ABB206  \n",
       "49874   766  鄂ACK879  \n",
       "\n",
       "[49875 rows x 9 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df3=pd.merge(df3, df4[[\"车辆信息\",\"具体车牌号\"]], on=\"车辆信息\", how='left')\n",
    "merged_df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "683450e8-82ce-45ba-aaea-64eb0d4ca5c3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>发货记录ID</th>\n",
       "      <th>发货记录完成时间</th>\n",
       "      <th>发货吨位</th>\n",
       "      <th>到站吨位</th>\n",
       "      <th>单价</th>\n",
       "      <th>货款</th>\n",
       "      <th>具体车牌号</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>2509</td>\n",
       "      <td>2022-07-21 07:10:48</td>\n",
       "      <td>38.38</td>\n",
       "      <td>0.0</td>\n",
       "      <td>207.0</td>\n",
       "      <td>7944.66</td>\n",
       "      <td>鄂L1D516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2510</td>\n",
       "      <td>2022-07-21 07:19:48</td>\n",
       "      <td>45.56</td>\n",
       "      <td>0.0</td>\n",
       "      <td>340.0</td>\n",
       "      <td>15490.40</td>\n",
       "      <td>鄂AEJ919</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2514</td>\n",
       "      <td>2022-07-21 10:49:34</td>\n",
       "      <td>43.84</td>\n",
       "      <td>0.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>14028.80</td>\n",
       "      <td>鄂ASE558</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>2515</td>\n",
       "      <td>2022-07-21 10:49:35</td>\n",
       "      <td>52.20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>320.0</td>\n",
       "      <td>16704.00</td>\n",
       "      <td>鄂APP387</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>2516</td>\n",
       "      <td>2022-07-21 11:23:31</td>\n",
       "      <td>32.32</td>\n",
       "      <td>0.0</td>\n",
       "      <td>292.0</td>\n",
       "      <td>9437.44</td>\n",
       "      <td>鄂APS131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49870</th>\n",
       "      <td>49870</td>\n",
       "      <td>60712</td>\n",
       "      <td>2024-06-24 13:28:49</td>\n",
       "      <td>36.00</td>\n",
       "      <td>0.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>1800.00</td>\n",
       "      <td>鄂AET276</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49871</th>\n",
       "      <td>49871</td>\n",
       "      <td>60713</td>\n",
       "      <td>2024-06-24 14:08:54</td>\n",
       "      <td>41.16</td>\n",
       "      <td>0.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>6379.80</td>\n",
       "      <td>鄂ABQ252</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49872</th>\n",
       "      <td>49872</td>\n",
       "      <td>60714</td>\n",
       "      <td>2024-06-24 14:09:20</td>\n",
       "      <td>34.60</td>\n",
       "      <td>0.0</td>\n",
       "      <td>155.0</td>\n",
       "      <td>5363.00</td>\n",
       "      <td>鄂ADM620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49873</th>\n",
       "      <td>49873</td>\n",
       "      <td>60715</td>\n",
       "      <td>2024-06-24 14:40:16</td>\n",
       "      <td>40.64</td>\n",
       "      <td>0.0</td>\n",
       "      <td>170.0</td>\n",
       "      <td>6908.80</td>\n",
       "      <td>鄂ABB206</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49874</th>\n",
       "      <td>49874</td>\n",
       "      <td>60716</td>\n",
       "      <td>2024-06-24 15:07:41</td>\n",
       "      <td>35.68</td>\n",
       "      <td>0.0</td>\n",
       "      <td>150.0</td>\n",
       "      <td>5352.00</td>\n",
       "      <td>鄂ACK879</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>49875 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0  发货记录ID             发货记录完成时间   发货吨位  到站吨位     单价        货款  \\\n",
       "0               0    2509  2022-07-21 07:10:48  38.38   0.0  207.0   7944.66   \n",
       "1               1    2510  2022-07-21 07:19:48  45.56   0.0  340.0  15490.40   \n",
       "2               2    2514  2022-07-21 10:49:34  43.84   0.0  320.0  14028.80   \n",
       "3               3    2515  2022-07-21 10:49:35  52.20   0.0  320.0  16704.00   \n",
       "4               4    2516  2022-07-21 11:23:31  32.32   0.0  292.0   9437.44   \n",
       "...           ...     ...                  ...    ...   ...    ...       ...   \n",
       "49870       49870   60712  2024-06-24 13:28:49  36.00   0.0   50.0   1800.00   \n",
       "49871       49871   60713  2024-06-24 14:08:54  41.16   0.0  155.0   6379.80   \n",
       "49872       49872   60714  2024-06-24 14:09:20  34.60   0.0  155.0   5363.00   \n",
       "49873       49873   60715  2024-06-24 14:40:16  40.64   0.0  170.0   6908.80   \n",
       "49874       49874   60716  2024-06-24 15:07:41  35.68   0.0  150.0   5352.00   \n",
       "\n",
       "         具体车牌号  \n",
       "0      鄂L1D516  \n",
       "1      鄂AEJ919  \n",
       "2      鄂ASE558  \n",
       "3      鄂APP387  \n",
       "4      鄂APS131  \n",
       "...        ...  \n",
       "49870  鄂AET276  \n",
       "49871  鄂ABQ252  \n",
       "49872  鄂ADM620  \n",
       "49873  鄂ABB206  \n",
       "49874  鄂ACK879  \n",
       "\n",
       "[49875 rows x 8 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df3=merged_df3.drop(columns=\"车辆信息\")\n",
    "merged_df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "b9833f4c-d721-471b-a6c1-3f5f3f962838",
   "metadata": {},
   "outputs": [],
   "source": [
    "merged_df3.to_excel(\"新.xlsx\",index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "fd17f1a6-26ce-44a8-82d4-43b35aa0b9de",
   "metadata": {},
   "outputs": [],
   "source": [
    "df2.to_excel(\"df2.xlsx\",index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4e53da3c-3089-4032-b81e-177d7fbfcb3f",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
